package com.Iconcat.system.mapper;

import com.Iconcat.system.entity.CatPrize;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;


import io.lettuce.core.dynamic.annotation.Param;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;
import org.apache.ibatis.annotations.Update;

import java.util.List;


@Mapper
public interface CatPrizeMapper extends BaseMapper<CatPrize> {
    @Select("SELECT * FROM cat_prize ORDER BY weight DESC")
    List<CatPrize> selectPrizeList();
    @Select("SELECT prize_id FROM cat_prize where prize_name=${prize_name}")
    Integer selectPrizeIdByPrizeName(@Param("prize_name") String prizeName);


}
